ExcelReader Xojo Component

ExcelReader.Cell Class

A class that represent Excel cell.

Object
   Cell

class ExcelReader.Cell

Properties

ColumnNumberColumn number of the cell (zero based)
DateValueProperty to read date from Excel cell.
FormatReturns the format object for the cell. The format object can contain borders, fonts, colors and other such.
FormulaReturns formula contained in the cell or empty string if there was no formula.
MergeInfoReturns the MergeInfo for a cell or nil if the cell does not belong to a merge group.
RowNumberRow number of the cell (zero based)
StyleRuns()Returns style runs for the cell if the cell has multi styling set up else nil is returned.
TypeReturns type of the cell
ValueReturns the cell value.

Methods

DefinedNameReturns DefinedName object for the cell or nil if there was no name defined for the cell.

Enumerations

CellTypeA enum that represents different types of cells in the excel document.

Supported Platforms:

  • macOS Carbon
  • macOS Intel 32 bit
  • macOS Intel 64 bit
  • macOS Apple Silicon
  • Windows 32 bit
  • Windows 64 bit
  • Windows ARM 64 bit
  • Linux 32 bit
  • Linux 64 bit
  • Linux ARM 32 bit
  • iOS